19 January 2020

About The Project

This dashboard project utilize flexdashboard to create interactive visualization on Avocado Data Set from kaggle.

Features description
1. Price, displays plot visualization on avocado average price from year 2015-2018 grouped by type(conventional and organic).
2. Search, by default this will display avocado average price grouped by type(conventional and organic) then region. The region can be chosen via drop down menu. The plot then will adjust its visual according to region selected

All plot displayed generated with plotly.

Overview on Data set

This data was downloaded from the Hass Avocado Board website in May of 2018 & compiled into a single CSV. Here's how the Hass Avocado Board describes the data on their website.

Some relevant columns in the data set:

  • Date - The date of the observation
  • AveragePrice - the average price of a single avocado
  • type - conventional or organic
  • year - the year
  • Region - the city or region of the observation
  • Total Volume - Total number of avocados sold
  • 4046 - Total number of avocados with PLU 4046 sold
  • 4225 - Total number of avocados with PLU 4225 sold
  • 4770 - Total number of avocados with PLU 4770 sold

Plot

plot_ly(data = type_tibble, 
        x = ~Date, y = ~AveragePrice, color = ~type, 
        mode = "lines+markers") %>%
        layout(title = "Average Avocado Price by Type",
               xaxis = list(title = "Year"),
               yaxis = list(title = "Average Price"))

Plot